﻿CREATE TABLE [dbo].[Members] (
    [MemberId]           INT          IDENTITY (1, 1) NOT NULL,
    [CustomerId]         INT          NOT NULL,
    [PassportNo]         VARCHAR (20) NULL,
    [Address1]           VARCHAR (50) NOT NULL,
    [Address2]           VARCHAR (50) NULL,
    [Address3]           VARCHAR (50) NULL,
    [City]               VARCHAR (10) NOT NULL,
    [PostalCode]         VARCHAR (10) NOT NULL,
    [Country]            VARCHAR (50) NOT NULL,
    [PassportExpiryDate] DATE         NOT NULL,
    [MemberPoints]       INT          NOT NULL
);

